Tabela DgActiveSubstanceMap

Definicja tabeli DgActiveSubstanceMap

Name

DgActiveSubstanceMap

Code

DgActiveSubstanceMap

Comment

tabelka mapujaca substancje aktywne miedzy róznymi bazami leków (np. pharmidex i bazyl)


Lista kolumn tabeli DgActiveSubstanceMap

Name

Code

ActiveSubstanceID1

ActiveSubstanceID1

ActiveSubstanceID2

ActiveSubstanceID2

Active

Active


Kolumna ActiveSubstanceID1 tabeli DgActiveSubstanceMap

Definicja kolumny ActiveSubstanceID1 tabeli DgActiveSubstanceMap

Name

ActiveSubstanceID1

Code

ActiveSubstanceID1

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID substancji aktywnej


Kolumna ActiveSubstanceID2 tabeli DgActiveSubstanceMap

Definicja kolumny ActiveSubstanceID2 tabeli DgActiveSubstanceMap

Name

ActiveSubstanceID2

Code

ActiveSubstanceID2

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID substancji aktywnej


Kolumna Active tabeli DgActiveSubstanceMap

Definicja kolumny Active tabeli DgActiveSubstanceMap

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

 


Lista kluczy tabeli DgActiveSubstanceMap

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DgActiveSubstanceMap

Definicja klucza Identifier_1 tabeli DgActiveSubstanceMap

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment